Re: [INTERFACES] Retreiving Table info - Mailing list pgsql-interfaces

From Herouth Maoz
Subject Re: [INTERFACES] Retreiving Table info
Date
Msg-id l03130301b3704fbb3160@[147.233.159.109]
Whole thread Raw
In response to Retreiving Table info  (Alex Turner <aturner@maaco.com>)
List pgsql-interfaces
At 14:52 +0300 on 25/05/1999, Alex Turner wrote:


>
> however.. is it possible to open a connection to the database and
> determine what tables are in the database already?

Of course. It's a query, just like any other query, but you select the data
from the system catalogs rather than your own tables. Take a look in the
documentation - the manpage for "catalogs".

The table you should query is probably pg_class.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma




pgsql-interfaces by date:

Previous
From: Alex Turner
Date:
Subject: Retreiving Table info
Next
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] ECPG feature